﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="PointsListLoad.ascx.cs" Inherits="webUserControl_PointsListLoad" %>
<%@ Register assembly="Infragistics2.WebUI.UltraWebGrid.v8.1, Version=8.1.20081.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebGrid" tagprefix="igtbl" %>
<%@ Register assembly="Infragistics2.WebUI.UltraWebGrid.ExcelExport.v8.1, Version=8.1.20081.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebGrid.ExcelExport" tagprefix="igtblexp" %>

<asp:Panel ID="Panel2" runat="server">
     <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        
         
         SelectCommand="SELECT SupplierName AS 名称, SupplierName2 AS 楼层, isType AS 类型, CityName AS 城市, DistrictName AS 地区, DangCiName AS 档次, ClassName AS 分类, Linkman AS 联络人, TelPhone AS 电话, Addre AS 地址, CustomerName AS 客户名, CustomerAddress AS 客户地址, CustomerTelPhone AS 客户电话, CustomerLinkMan AS 客户联络人, NumMale AS 男点位, NumFemale AS 女点位, NumHongGan AS 烘干点位, NumBaoJian AS 包间点位, NumQiTa AS [其他/消防点位], endTime AS 截至时间 FROM dbo.vw_OrderDetail WHERE (CustomerID = @CustomerID) AND (Status = 0) ORDER BY SupplierName, SupplierName2, CityName, DistrictName, DangCiName, ClassName, Linkman, TelPhone, Addre">
         <SelectParameters>
             <asp:QueryStringParameter DefaultValue="" Name="CustomerID" 
                 QueryStringField="ID" />
         </SelectParameters>
    </asp:SqlDataSource>
    <igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server" 
        DataSourceID="SqlDataSource3" Height="300px" Width="100%">
        <Bands>
            <igtbl:UltraGridBand>
                <Columns>
                    <igtbl:UltraGridColumn BaseColumnName="名称" IsBound="True" Key="名称">
                        <Header Caption="名称">
                        </Header>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="楼层" IsBound="True" Key="楼层">
                        <Header Caption="楼层">
                            <RowLayoutColumnInfo OriginX="1" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="1" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="类型" IsBound="True" Key="类型">
                        <Header Caption="类型">
                            <RowLayoutColumnInfo OriginX="2" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="2" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="城市" IsBound="True" Key="城市">
                        <Header Caption="城市">
                            <RowLayoutColumnInfo OriginX="2" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="2" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="地区" IsBound="True" Key="地区">
                        <Header Caption="地区">
                            <RowLayoutColumnInfo OriginX="3" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="3" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="档次" IsBound="True" Key="档次">
                        <Header Caption="档次">
                            <RowLayoutColumnInfo OriginX="4" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="4" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="分类" IsBound="True" Key="分类">
                        <Header Caption="分类">
                            <RowLayoutColumnInfo OriginX="5" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="5" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="联络人" IsBound="True" Key="联络人">
                        <Header Caption="联络人">
                            <RowLayoutColumnInfo OriginX="6" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="6" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="电话" IsBound="True" Key="电话">
                        <Header Caption="电话">
                            <RowLayoutColumnInfo OriginX="7" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="7" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="地址" IsBound="True" Key="地址">
                        <Header Caption="地址">
                            <RowLayoutColumnInfo OriginX="8" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="8" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="客户名" IsBound="True" Key="客户名">
                        <Header Caption="客户名">
                            <RowLayoutColumnInfo OriginX="9" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="9" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="客户地址" IsBound="True" Key="客户地址">
                        <Header Caption="客户地址">
                            <RowLayoutColumnInfo OriginX="10" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="10" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="客户电话" IsBound="True" Key="客户电话">
                        <Header Caption="客户电话">
                            <RowLayoutColumnInfo OriginX="11" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="11" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="客户联络人" IsBound="True" Key="客户联络人">
                        <Header Caption="客户联络人">
                            <RowLayoutColumnInfo OriginX="12" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="12" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="男点位" DataType="System.Int32" 
                        IsBound="True" Key="男点位">
                        <Header Caption="男点位">
                            <RowLayoutColumnInfo OriginX="13" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="13" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="女点位" DataType="System.Int32" 
                        IsBound="True" Key="女点位">
                        <Header Caption="女点位">
                            <RowLayoutColumnInfo OriginX="14" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="14" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="烘干点位" DataType="System.Int32" 
                        IsBound="True" Key="烘干点位">
                        <Header Caption="烘干点位">
                            <RowLayoutColumnInfo OriginX="15" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="15" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="包间点位" DataType="System.Int32" 
                        IsBound="True" Key="包间点位">
                        <Header Caption="包间点位">
                            <RowLayoutColumnInfo OriginX="16" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="16" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="其他/消防点位" DataType="System.Int32" 
                        IsBound="True" Key="其他/消防点位">
                        <Header Caption="其他/消防点位">
                            <RowLayoutColumnInfo OriginX="17" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="17" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                    <igtbl:UltraGridColumn BaseColumnName="截至时间" DataType="System.DateTime" 
                        IsBound="True" Key="截至时间">
                        <Header Caption="截至时间">
                            <RowLayoutColumnInfo OriginX="18" />
                        </Header>
                        <Footer>
                            <RowLayoutColumnInfo OriginX="18" />
                        </Footer>
                    </igtbl:UltraGridColumn>
                </Columns>
                <AddNewRow View="NotSet" Visible="NotSet">
                </AddNewRow>
            </igtbl:UltraGridBand>
        </Bands>
        <DisplayLayout AllowColSizingDefault="Free" AllowColumnMovingDefault="OnServer" 
            AllowDeleteDefault="Yes" AllowSortingDefault="OnClient" 
            AllowUpdateDefault="Yes" BorderCollapseDefault="Separate" 
            HeaderClickActionDefault="SortMulti" Name="ctl00xUltraWebGrid1" 
            RowHeightDefault="20px" RowSelectorsDefault="No" 
            SelectTypeRowDefault="Extended" StationaryMargins="Header" 
            StationaryMarginsOutlookGroupBy="True" TableLayout="Fixed" Version="4.00" 
            ViewType="OutlookGroupBy">
            <FrameStyle BackColor="Window" BorderColor="InactiveCaption" 
                BorderStyle="Solid" BorderWidth="1px" Font-Names="Microsoft Sans Serif" 
                Font-Size="8.25pt" ForeColor="Black" Height="300px" Width="100%">
            </FrameStyle>
            <Pager MinimumPagesForDisplay="2">
                <PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
                <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                    WidthTop="1px" />
                </PagerStyle>
            </Pager>
            <EditCellStyleDefault BorderStyle="None" BorderWidth="0px">
            </EditCellStyleDefault>
            <FooterStyleDefault BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
                <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                    WidthTop="1px" />
            </FooterStyleDefault>
            <HeaderStyleDefault BackColor="LightGray" BorderStyle="Solid" 
                HorizontalAlign="Left">
                <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                    WidthTop="1px" />
            </HeaderStyleDefault>
            <RowStyleDefault BackColor="Window" BorderColor="Silver" BorderStyle="Solid" 
                BorderWidth="1px" Font-Names="Microsoft Sans Serif" Font-Size="8.25pt">
                <Padding Left="3px" />
                <BorderDetails ColorLeft="Window" ColorTop="Window" />
            </RowStyleDefault>
            <GroupByRowStyleDefault BackColor="Control" BorderColor="Window">
            </GroupByRowStyleDefault>
            <GroupByBox Prompt="">
                <BoxStyle BackColor="ActiveBorder" BorderColor="Window">
                </BoxStyle>
            </GroupByBox>
            <AddNewBox Hidden="False">
                <BoxStyle BackColor="Window" BorderColor="InactiveCaption" BorderStyle="Solid" 
                    BorderWidth="1px">
                    <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                        WidthTop="1px" />
                </BoxStyle>
            </AddNewBox>
            <ActivationObject BorderColor="" BorderWidth="">
            </ActivationObject>
            <FilterOptionsDefault>
                <FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" 
                    BorderWidth="1px" CustomRules="overflow:auto;" 
                    Font-Names="Verdana,Arial,Helvetica,sans-serif" Font-Size="11px" Height="300px" 
                    Width="200px">
                    <Padding Left="2px" />
                </FilterDropDownStyle>
                <FilterHighlightRowStyle BackColor="#151C55" ForeColor="White">
                </FilterHighlightRowStyle>
                <FilterOperandDropDownStyle BackColor="White" BorderColor="Silver" 
                    BorderStyle="Solid" BorderWidth="1px" CustomRules="overflow:auto;" 
                    Font-Names="Verdana,Arial,Helvetica,sans-serif" Font-Size="11px">
                    <Padding Left="2px" />
                </FilterOperandDropDownStyle>
            </FilterOptionsDefault>
        </DisplayLayout>
    </igtbl:UltraWebGrid>
    <igtblexp:UltraWebGridExcelExporter ID="UltraWebGridExcelExporter1" 
        runat="server">
    </igtblexp:UltraWebGridExcelExporter>
    <asp:Button ID="btnExportExcel" runat="server" onclick="btnExportExcel_Click" 
        Text="导出Excel" />
    
    </asp:Panel>